package LawsonTransformJava.data;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;


public class TblAltRates {
	public int company	=0;
	public int employee	=0;
	public int seq_nbr	=0;
	public String job_code	=null;
	public String pay_code	=null;
	public float pay_rate	=0;
	public Date effect_date=null;
	public Date end_date=null;
	public String position	=null;
	public String process_level	=null;
	public String department	=null;
	public String currency_code	=null;
	public int curr_nd	=0;
	
	private DateFormat df = new SimpleDateFormat("MM/dd/yyyy");
	private DateFormat df2 = new SimpleDateFormat("yyyyMMdd");
	private String text; 
	
	public void setCompany(int company) {
		this.company = company;
	}
	public void setEmployee(int employee) {
		this.employee = employee;
	}
	public void setSeq_nbr(int seq_nbr) {
		this.seq_nbr = seq_nbr;
	}
	public void setJob_code(String job_code) {
		this.job_code = job_code;
	}
	public void setPay_code(String pay_code) {
		this.pay_code = pay_code;
	}
	public void setPay_rate(float pay_rate) {
		this.pay_rate = pay_rate;
	}
	public void setEffect_date(Date effect_date) {
		this.effect_date = effect_date;
	}
	public void setEnd_date(Date end_date) {
		this.end_date = end_date;
	}
	public void setPosition(String position) {
		this.position = position;
	}
	public void setProcess_level(String process_level) {
		this.process_level = process_level;
	}
	public void setDepartment(String department) {
		this.department = department;
	}
	public void setCurrency_code(String currency_code) {
		this.currency_code = currency_code;
	}
	public void setCurr_nd(int curr_nd) {
		this.curr_nd = curr_nd;
	}
	
	
	public int getCompany() {
		return company;
	}
	public int getEmployee() {
		return employee;
	}
	public int getSeq_nbr() {
		return seq_nbr;
	}
	public String getJob_code() {
		if (job_code==null||job_code.equals(""))
		{text = "";}
	else
		{text = "\""+job_code+"\"";}
	return text;
	}
	public String getPay_code() {
		if (pay_code==null||pay_code.equals(""))
		{text = "";}
	else
		{text = "\""+pay_code+"\"";}
	return text;
	}
	public float getPay_rate() {
		return pay_rate;
	}
	public String getEffect_date() {
		if (effect_date==null)
		{text = "";}
		else
		{String date =(effect_date!=null?df2.format(effect_date).toString():""); 
		if (date.equals("17000101"))
			{text = "";}
		else
			{text ="\"" + df.format(effect_date).toString() + "\"";;}}
		return text;			
				
	}
	public String getEnd_date() {
		if (end_date==null)
		{text = "";}
		else
		{String date =(end_date!=null?df2.format(end_date).toString():""); 
		if (date.equals("17000101"))
			{text = "";}
		else
			{text ="\"" + df.format(end_date).toString() + "\"";;}}
		return text;				
	}
	public String getPosition() {
		if (position==null||position.equals(""))
		{text = "";}
	else
		{text = "\""+position+"\"";}
	return text;		
	}
	public String getProcess_level() {
		if (process_level==null||process_level.equals(""))
		{text = "";}
	else
		{text = "\""+process_level+"\"";}
	return text;		
	}
	public String getDepartment() {
		if (department==null||department.equals(""))
		{text = "";}
	else
		{text = "\""+department+"\"";}
	return text;		
	}
	public String getCurrency_code() {
		if (currency_code==null||currency_code.equals(""))
		{text = "";}
	else
		{text = "\""+currency_code+"\"";}
	return text;		
	}
	public int getCurr_nd() {
		return curr_nd;
	}
	
	
}
